{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Bond Example"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Bond Example","index":0,"n_rows":82,"n_cols":152,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["5.1.3.7. Bonds and preferred shares with embedded options"]
[]
["Yield Curve Simulation"]
["2023-12-31",null,1,{"$f":"C4+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,{"$f":"AI4+1","v":34},35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,{"$f":"BO4+1","v":66},67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,{"$f":"CU4+1","v":98},99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,{"$f":"EA4+1","v":130},131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150]
["Year",null,1,{"$f":"C5+1","v":2},{"$f":"D5+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[]
["Yield Curves"]
["Initial Scenario",null,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.8000000000000003E-2,5.79E-2,5.7800000000000011E-2,5.7700000000000001E-2,5.7600000000000005E-2,5.7499999999999996E-2,5.7400000000000007E-2,5.7299999999999997E-2,5.7200000000000001E-2,5.7100000000000005E-2,5.7000000000000002E-2,5.6900000000000006E-2,5.680000000000001E-2,5.6700000000000007E-2,5.6600000000000004E-2,5.6500000000000002E-2,5.6399999999999999E-2,5.6300000000000003E-2,5.62E-2,5.6100000000000004E-2,5.6000000000000001E-2,5.5900000000000005E-2,5.5800000000000002E-2,5.5700000000000006E-2,5.5600000000000004E-2,5.5500000000000001E-2,5.5399999999999998E-2,5.5300000000000002E-2,5.5200000000000006E-2,5.5100000000000003E-2,5.5E-2,5.4900000000000004E-2,5.4800000000000001E-2,5.4699999999999999E-2,5.4600000000000003E-2,5.45E-2,5.4399999999999997E-2,5.4300000000000008E-2,5.4200000000000005E-2,5.4100000000000002E-2,5.3999999999999999E-2,5.3900000000000003E-2,5.3800000000000001E-2,5.3699999999999998E-2,5.3599999999999995E-2,5.3499999999999999E-2,5.3399999999999996E-2,5.33E-2,5.3200000000000004E-2,5.3100000000000001E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2,5.2999999999999999E-2]
["Scenario 1",null,3.2053072663591649E-2,3.2365558195777355E-2,3.2678043727963069E-2,3.2990529260148782E-2,3.3303014792334489E-2,3.3615500324520195E-2,3.3927985856705908E-2,3.4240471388891622E-2,3.4552956921077328E-2,3.4865442453263042E-2,3.5177927985448748E-2,3.5490413517634462E-2,3.5802899049820175E-2,3.6115384582005881E-2,3.6427870114191595E-2,3.6740355646377301E-2,3.7052841178563015E-2,3.7365326710748728E-2,3.7677812242934441E-2,3.7990297775120141E-2,3.8210491819617734E-2,3.8430685864115341E-2,3.8650879908612934E-2,3.8871073953110534E-2,3.909126799760812E-2,3.9311462042105727E-2,3.953165608660332E-2,3.975185013110092E-2,3.997204417559852E-2,4.0192238220096113E-2,4.041243226459372E-2,4.0632626309091313E-2,4.0852820353588913E-2,4.1073014398086506E-2,4.1293208442584099E-2,4.1513402487081699E-2,4.1733596531579292E-2,4.1953790576076892E-2,4.2173984620574492E-2,4.2394178665072085E-2,4.2614372709569685E-2,4.2834566754067285E-2,4.3054760798564885E-2,4.3274954843062478E-2,4.3495148887560071E-2,4.3715342932057664E-2,4.3935536976555264E-2,4.4155731021052871E-2,4.4375925065550464E-2,4.4596119110048058E-2,4.4816313154545658E-2,4.5036507199043251E-2,4.5256701243540851E-2,4.5476895288038444E-2,4.5697089332536044E-2,4.5917283377033637E-2,4.6137477421531244E-2,4.6357671466028837E-2,4.6577865510526437E-2,4.679805955502403E-2,4.701825359952163E-2,4.7238447644019223E-2,4.7458641688516816E-2,4.7678835733014416E-2,4.7899029777512016E-2,4.8119223822009609E-2,4.8339417866507209E-2,4.8559611911004809E-2,4.8779805955502402E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2]
["Scenario 2",null,8.5716772533518254E-2,8.4292442567411627E-2,8.2868112601305013E-2,8.1443782635198386E-2,8.0019452669091759E-2,7.8595122702985132E-2,7.7170792736878518E-2,7.5746462770771891E-2,7.4322132804665264E-2,7.2897802838558651E-2,7.1473472872452024E-2,7.0049142906345396E-2,6.8624812940238769E-2,6.7200482974132142E-2,6.5776153008025529E-2,6.4351823041918901E-2,6.2927493075812274E-2,6.1503163109705654E-2,6.0078833143599034E-2,5.8654503177492406E-2,5.8461413113942554E-2,5.8268323050392715E-2,5.8075232986842862E-2,5.7882142923293016E-2,5.7689052859743156E-2,5.7495962796193324E-2,5.7302872732643464E-2,5.7109782669093619E-2,5.6916692605543773E-2,5.6723602541993927E-2,5.6530512478444081E-2,5.6337422414894235E-2,5.6144332351344382E-2,5.5951242287794536E-2,5.5758152224244684E-2,5.5565062160694831E-2,5.5371972097144992E-2,5.5178882033595139E-2,5.4985791970045293E-2,5.479270190649544E-2,5.4599611842945601E-2,5.4406521779395749E-2,5.4213431715845903E-2,5.402034165229605E-2,5.3827251588746204E-2,5.3634161525196351E-2,5.3441071461646505E-2,5.3247981398096667E-2,5.3054891334546814E-2,5.2861801270996961E-2,5.2668711207447115E-2,5.2475621143897269E-2,5.2282531080347416E-2,5.208944101679757E-2,5.1896350953247718E-2,5.1703260889697872E-2,5.1510170826148033E-2,5.131708076259818E-2,5.1123990699048334E-2,5.0930900635498481E-2,5.0737810571948636E-2,5.0544720508398783E-2,5.0351630444848937E-2,5.0158540381299084E-2,4.9965450317749238E-2,4.9772360254199385E-2,4.9579270190649546E-2,4.9386180127099701E-2,4.9193090063549848E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2,4.9000000000000002E-2]
["Scenario 3",null,9.358742733640836E-2,9.3062281804222657E-2,9.2537136272036941E-2,9.2011990739851224E-2,9.1486845207665507E-2,9.0961699675479818E-2,9.0436554143294101E-2,8.9911408611108384E-2,8.9386263078922668E-2,8.8861117546736965E-2,8.8335972014551262E-2,8.7810826482365545E-2,8.7285680950179828E-2,8.6760535417994125E-2,8.6235389885808408E-2,8.5710244353622705E-2,8.5185098821436989E-2,8.4659953289251286E-2,8.4134807757065569E-2,8.3609662224879866E-2,8.3077468980382263E-2,8.2545275735884674E-2,8.2013082491387071E-2,8.1480889246889482E-2,8.0948696002391865E-2,8.0416502757894276E-2,7.9884309513396673E-2,7.9352116268899084E-2,7.8819923024401495E-2,7.8287729779903892E-2,7.7755536535406289E-2,7.72233432909087E-2,7.6691150046411111E-2,7.6158956801913508E-2,7.5626763557415905E-2,7.5094570312918302E-2,7.4562377068420713E-2,7.403018382392311E-2,7.3497990579425521E-2,7.2965797334927918E-2,7.2433604090430329E-2,7.1901410845932726E-2,7.1369217601435136E-2,7.0837024356937534E-2,7.0304831112439931E-2,6.9772637867942328E-2,6.9240444623444738E-2,6.8708251378947149E-2,6.8176058134449546E-2,6.7643864889951943E-2,6.7111671645454354E-2,6.6579478400956751E-2,6.6047285156459148E-2,6.5515091911961559E-2,6.4982898667463956E-2,6.4450705422966353E-2,6.3918512178468778E-2,6.3386318933971175E-2,6.2854125689473572E-2,6.2321932444975969E-2,6.178973920047838E-2,6.1257545955980777E-2,6.0725352711483174E-2,6.0193159466985578E-2,5.9660966222487982E-2,5.9128772977990386E-2,5.859657973349279E-2,5.8064386488995201E-2,5.7532193244497598E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2]
["Scenario 4",null,3.7998187466481745E-2,3.9255797432588377E-2,4.0513407398694995E-2,4.177101736480162E-2,4.3028627330908245E-2,4.428623729701487E-2,4.5543847263121488E-2,4.6801457229228113E-2,4.8059067195334738E-2,4.9316677161441363E-2,5.0574287127547989E-2,5.1831897093654614E-2,5.3089507059761239E-2,5.4347117025867857E-2,5.5604726991974482E-2,5.6862336958081107E-2,5.8119946924187732E-2,5.9377556890294357E-2,6.0635166856400975E-2,6.18927768225076E-2,6.1794921286057444E-2,6.1697065749607302E-2,6.1599210213157146E-2,6.1501354676706997E-2,6.1403499140256834E-2,6.1305643603806692E-2,6.1207788067356529E-2,6.110993253090638E-2,6.1012076994456238E-2,6.0914221458006082E-2,6.0816365921555933E-2,6.0718510385105784E-2,6.0620654848655628E-2,6.0522799312205472E-2,6.0424943775755316E-2,6.0327088239305167E-2,6.0229232702855018E-2,6.0131377166404862E-2,6.0033521629954713E-2,5.9935666093504557E-2,5.9837810557054415E-2,5.9739955020604259E-2,5.964209948415411E-2,5.9544243947703954E-2,5.9446388411253798E-2,5.9348532874803642E-2,5.92506773383535E-2,5.9152821801903351E-2,5.9054966265453195E-2,5.8957110729003039E-2,5.885925519255289E-2,5.8761399656102734E-2,5.8663544119652584E-2,5.8565688583202435E-2,5.8467833046752279E-2,5.8369977510302123E-2,5.8272121973851981E-2,5.8174266437401825E-2,5.8076410900951676E-2,5.797855536450152E-2,5.7880699828051371E-2,5.7782844291601215E-2,5.7684988755151059E-2,5.7587133218700903E-2,5.7489277682250761E-2,5.7391422145800605E-2,5.7293566609350456E-2,5.7195711072900307E-2,5.7097855536450151E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2,5.6999999999999995E-2]
[]
["Discount Rates"]
["Initial Scenario",null,{"$f":"1/(1+C8)^C$5","v":0.94517958412098291},{"$f":"1/(1+D8)^D$5","v":0.89336444623911437},{"$f":"1/(1+E8)^E$5","v":0.84438983576475835},{"$f":"1/(1+F8)^F$5","v":0.79810003380411942},{"$f":"1/(1+G8)^G$5","v":0.75434785803792004},{"$f":"1/(1+H8)^H$5","v":0.71299419474283554},{"$f":"1/(1+I8)^I$5","v":0.6739075564677085},{"$f":"1/(1+J8)^J$5","v":0.63696366395813664},{"$f":"1/(1+K8)^K$5","v":0.60204505100012906},{"$f":"1/(1+L8)^L$5","v":0.56904069092639809},{"$f":"1/(1+M8)^M$5","v":0.53784564359772968},{"$f":"1/(1+N8)^N$5","v":0.50836072173698466},{"$f":"1/(1+O8)^O$5","v":0.48049217555480589},{"$f":"1/(1+P8)^P$5","v":0.45415139466427767},{"$f":"1/(1+Q8)^Q$5","v":0.42925462633674644},{"$f":"1/(1+R8)^R$5","v":0.40572270920297399},{"$f":"1/(1+S8)^S$5","v":0.38348082155290547},{"$f":"1/(1+T8)^T$5","v":0.36245824343374811},{"$f":"1/(1+U8)^U$5","v":0.34258813178993203},{"$f":"1/(1+V8)^V$5","v":0.32380730792999246},{"$f":"1/(1+W8)^W$5","v":0.3066641723681281},{"$f":"1/(1+X8)^X$5","v":0.29048360185282912},{"$f":"1/(1+Y8)^Y$5","v":0.27520885272918377},{"$f":"1/(1+Z8)^Z$5","v":0.26078666985193905},{"$f":"1/(1+AA8)^AA$5","v":0.24716706401579161},{"$f":"1/(1+AB8)^AB$5","v":0.23430310406652496},{"$f":"1/(1+AC8)^AC$5","v":0.22215072269487712},{"$f":"1/(1+AD8)^AD$5","v":0.21066853498481347},{"$f":"1/(1+AE8)^AE$5","v":0.19981766885260036},{"$f":"1/(1+AF8)^AF$5","v":0.18956160657325169}]
["Scenario 1",null,{"$f":"1/(1+C9)^C$5","v":0.96894241826065497},{"$f":"1/(1+D9)^D$5","v":0.93828113744701747},{"$f":"1/(1+E9)^E$5","v":0.90804039698479044},{"$f":"1/(1+F9)^F$5","v":0.8782428863906},{"$f":"1/(1+G9)^G$5","v":0.84890974194164015},{"$f":"1/(1+H9)^H$5","v":0.82006054813028717},{"$f":"1/(1+I9)^I$5","v":0.79171334373517344},{"$f":"1/(1+J9)^J$5","v":0.76388463232658421},{"$f":"1/(1+K9)^K$5","v":0.73658939701184245},{"$f":"1/(1+L9)^L$5","v":0.70984111921545445},{"$f":"1/(1+M9)^M$5","v":0.68365180127931269},{"$f":"1/(1+N9)^N$5","v":0.65803199266015555},{"$f":"1/(1+O9)^O$5","v":0.63299081949473213},{"$f":"1/(1+P9)^P$5","v":0.60853601729777906},{"$f":"1/(1+Q9)^Q$5","v":0.58467396655380699},{"$f":"1/(1+R9)^R$5","v":0.56140973096104363},{"$f":"1/(1+S9)^S$5","v":0.53874709808432986},{"$f":"1/(1+T9)^T$5","v":0.51668862217355993},{"$f":"1/(1+U9)^U$5","v":0.49523566890514154},{"$f":"1/(1+V9)^V$5","v":0.47438846180604644},{"$f":"1/(1+W9)^W$5","v":0.45499467976912039},{"$f":"1/(1+X9)^X$5","v":0.43620908932124436},{"$f":"1/(1+Y9)^Y$5","v":0.41802220587366795},{"$f":"1/(1+Z9)^Z$5","v":0.40042418710125693},{"$f":"1/(1+AA9)^AA$5","v":0.38340486462934964},{"$f":"1/(1+AB9)^AB$5","v":0.36695377505445326},{"$f":"1/(1+AC9)^AC$5","v":0.35106019024920448},{"$f":"1/(1+AD9)^AD$5","v":0.33571314690626491},{"$f":"1/(1+AE9)^AE$5","v":0.32090147528009672},{"$f":"1/(1+AF9)^AF$5","v":0.30661382708964507}]
["Scenario 2",null,{"$f":"1/(1+C10)^C$5","v":0.92105052192064951},{"$f":"1/(1+D10)^D$5","v":0.85056427637006349},{"$f":"1/(1+E10)^E$5","v":0.78754123893271555},{"$f":"1/(1+F10)^F$5","v":0.73111249688868019},{"$f":"1/(1+G10)^G$5","v":0.68052190793944334},{"$f":"1/(1+H10)^H$5","v":0.63511049192170443},{"$f":"1/(1+I10)^I$5","v":0.59430312834430599},{"$f":"1/(1+J10)^J$5","v":0.55759720247226396},{"$f":"1/(1+K10)^K$5","v":0.52455290069825633},{"$f":"1/(1+L10)^L$5","v":0.49478490417676524},{"$f":"1/(1+M10)^M$5","v":0.46795526986006836},{"$f":"1/(1+N10)^N$5","v":0.44376732157098631},{"$f":"1/(1+O10)^O$5","v":0.42196040172564653},{"$f":"1/(1+P10)^P$5","v":0.40230535772674042},{"$f":"1/(1+Q10)^Q$5","v":0.38460065666305293},{"$f":"1/(1+R10)^R$5","v":0.36866903841656584},{"$f":"1/(1+S10)^S$5","v":0.3543546311250208},{"$f":"1/(1+T10)^T$5","v":0.34152046461414837},{"$f":"1/(1+U10)^U$5","v":0.33004632726378036},{"$f":"1/(1+V10)^V$5","v":0.31982692010772057},{"$f":"1/(1+W10)^W$5","v":0.30326644937875302},{"$f":"1/(1+X10)^X$5","v":0.28766860901253677},{"$f":"1/(1+Y10)^Y$5","v":0.27297280323813633},{"$f":"1/(1+Z10)^Z$5","v":0.25912250234392031},{"$f":"1/(1+AA10)^AA$5","v":0.24606495486130572},{"$f":"1/(1+AB10)^AB$5","v":0.23375092108534551},{"$f":"1/(1+AC10)^AC$5","v":0.22213442628452357},{"$f":"1/(1+AD10)^AD$5","v":0.21117253208410566},{"$f":"1/(1+AE10)^AE$5","v":0.20082512462842256},{"$f":"1/(1+AF10)^AF$5","v":0.19105471823852196}]
["Scenario 3",null,{"$f":"1/(1+C11)^C$5","v":0.91442163196375237},{"$f":"1/(1+D11)^D$5","v":0.83697056195182884},{"$f":"1/(1+E11)^E$5","v":0.76681637100809807},{"$f":"1/(1+F11)^F$5","v":0.7032186360577628},{"$f":"1/(1+G11)^G$5","v":0.64551668263153295},{"$f":"1/(1+H11)^H$5","v":0.59312055539986763},{"$f":"1/(1+I11)^I$5","v":0.54550305621473838},{"$f":"1/(1+J11)^J$5","v":0.50219271854636605},{"$f":"1/(1+K11)^K$5","v":0.46276760386578963},{"$f":"1/(1+L11)^L$5","v":0.42684982000306321},{"$f":"1/(1+M11)^M$5","v":0.39410067409997052},{"$f":"1/(1+N11)^N$5","v":0.36421638372921267},{"$f":"1/(1+O11)^O$5","v":0.33692427928786101},{"$f":"1/(1+P11)^P$5","v":0.31197943908031989},{"$f":"1/(1+Q11)^Q$5","v":0.2891617057479195},{"$f":"1/(1+R11)^R$5","v":0.2682730390194572},{"$f":"1/(1+S11)^S$5","v":0.24913516527101939},{"$f":"1/(1+T11)^T$5","v":0.23158748919957611},{"$f":"1/(1+U11)^U$5","v":0.21548523712405002},{"$f":"1/(1+V11)^V$5","v":0.20069780510876031},{"$f":"1/(1+W11)^W$5","v":0.18713285810055535},{"$f":"1/(1+X11)^X$5","v":0.17465719463987542},{"$f":"1/(1+Y11)^Y$5","v":0.1631744766592424},{"$f":"1/(1+Z11)^Z$5","v":0.15259756824649096},{"$f":"1/(1+AA11)^AA$5","v":0.14284760099246649},{"$f":"1/(1+AB11)^AB$5","v":0.1338531393785303},{"$f":"1/(1+AC11)^AC$5","v":0.12554943499990218},{"$f":"1/(1+AD11)^AD$5","v":0.11787775972715864},{"$f":"1/(1+AE11)^AE$5","v":0.11078480905650055},{"$f":"1/(1+AF11)^AF$5","v":0.1042221679096647}]
["Scenario 4",null,{"$f":"1/(1+C12)^C$5","v":0.96339281905758756},{"$f":"1/(1+D12)^D$5","v":0.92588082138688443},{"$f":"1/(1+E12)^E$5","v":0.88768106911043843},{"$f":"1/(1+F12)^F$5","v":0.84900630637701657},{"$f":"1/(1+G12)^G$5","v":0.81006311569780076},{"$f":"1/(1+H12)^H$5","v":0.77105023397615391},{"$f":"1/(1+I12)^I$5","v":0.73215704454129749},{"$f":"1/(1+J12)^J$5","v":0.69356225773808},{"$f":"1/(1+K12)^K$5","v":0.65543278882642519},{"$f":"1/(1+L12)^L$5","v":0.61792283818808269},{"$f":"1/(1+M12)^M$5","v":0.58117317520263523},{"$f":"1/(1+N12)^N$5","v":0.54531062370940586},{"$f":"1/(1+O12)^O$5","v":0.51044774377824453},{"$f":"1/(1+P12)^P$5","v":0.47668270162186055},{"$f":"1/(1+Q12)^Q$5","v":0.44409931693625226},{"$f":"1/(1+R12)^R$5","v":0.41276727478428271},{"$f":"1/(1+S12)^S$5","v":0.38274248735978422},{"$f":"1/(1+T12)^T$5","v":0.35406758959451257},{"$f":"1/(1+U12)^U$5","v":0.32677255159671365},{"$f":"1/(1+V12)^V$5","v":0.30087539032729277},{"$f":"1/(1+W12)^W$5","v":0.28388763832356601},{"$f":"1/(1+X12)^X$5","v":0.26790845766062815},{"$f":"1/(1+Y12)^Y$5","v":0.25287535446325721},{"$f":"1/(1+Z12)^Z$5","v":0.23872985493144946},{"$f":"1/(1+AA12)^AA$5","v":0.2254172379397528},{"$f":"1/(1+AB12)^AB$5","v":0.21288628597044981},{"$f":"1/(1+AC12)^AC$5","v":0.20108905308821193},{"$f":"1/(1+AD12)^AD$5","v":0.18998064875728349},{"$f":"1/(1+AE12)^AE$5","v":0.17951903638881744},{"$f":"1/(1+AF12)^AF$5","v":0.16966484558613626}]
[]
["Cashflows to Different Call/Put Dates"]
[{"$f":"\"Y\" & COUNT(C22:AF22) & \" P\" & INDEX($C22:$AF22,COUNT($C22:$AF22))-7","v":"Y3 P100"},null,7,7,107]
[{"$f":"\"Y\" & COUNT(C23:AF23) & \" P\" & INDEX($C23:$AF23,COUNT($C23:$AF23))-7","v":"Y5 P102"},null,7,7,7,7,{"$f":"7+102","v":109}]
[{"$f":"\"Y\" & COUNT(C24:AF24) & \" C\" & INDEX($C24:$AF24,COUNT($C24:$AF24))-7","v":"Y5 C103"},null,7,7,7,7,{"$f":"7+103","v":110}]
[{"$f":"\"Y\" & COUNT(C25:AF25) & \" C\" & INDEX($C25:$AF25,COUNT($C25:$AF25))-7","v":"Y7 C100"},null,7,7,7,7,7,7,{"$f":"107","v":107}]
[{"$f":"\"Y\" & COUNT(C26:AF26) & \" P\" & INDEX($C26:$AF26,COUNT($C26:$AF26))-7","v":"Y8 P99"},null,7,7,7,7,7,7,7,{"$f":"7+99","v":106}]
[{"$f":"\"Y\" & COUNT(C27:AF27) & \" C\" & INDEX($C27:$AF27,COUNT($C27:$AF27))-7","v":"Y10 C100"},null,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C28:AF28) & \" C\" & INDEX($C28:$AF28,COUNT($C28:$AF28))-7","v":"Y11 C100"},null,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C29:AF29) & \" C\" & INDEX($C29:$AF29,COUNT($C29:$AF29))-7","v":"Y12 C100"},null,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C30:AF30) & \" C\" & INDEX($C30:$AF30,COUNT($C30:$AF30))-7","v":"Y13 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C31:AF31) & \" C\" & INDEX($C31:$AF31,COUNT($C31:$AF31))-7","v":"Y14 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C32:AF32) & \" C\" & INDEX($C32:$AF32,COUNT($C32:$AF32))-7","v":"Y15 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C33:AF33) & \" C\" & INDEX($C33:$AF33,COUNT($C33:$AF33))-7","v":"Y16 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C34:AF34) & \" C\" & INDEX($C34:$AF34,COUNT($C34:$AF34))-7","v":"Y17 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C35:AF35) & \" C\" & INDEX($C35:$AF35,COUNT($C35:$AF35))-7","v":"Y18 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C36:AF36) & \" C\" & INDEX($C36:$AF36,COUNT($C36:$AF36))-7","v":"Y19 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C37:AF37) & \" C\" & INDEX($C37:$AF37,COUNT($C37:$AF37))-7","v":"Y20 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C38:AF38) & \" C\" & INDEX($C38:$AF38,COUNT($C38:$AF38))-7","v":"Y21 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C39:AF39) & \" C\" & INDEX($C39:$AF39,COUNT($C39:$AF39))-7","v":"Y22 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C40:AF40) & \" C\" & INDEX($C40:$AF40,COUNT($C40:$AF40))-7","v":"Y23 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C41:AF41) & \" C\" & INDEX($C41:$AF41,COUNT($C41:$AF41))-7","v":"Y24 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C42:AF42) & \" C\" & INDEX($C42:$AF42,COUNT($C42:$AF42))-7","v":"Y25 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C43:AF43) & \" C\" & INDEX($C43:$AF43,COUNT($C43:$AF43))-7","v":"Y26 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C44:AF44) & \" C\" & INDEX($C44:$AF44,COUNT($C44:$AF44))-7","v":"Y27 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C45:AF45) & \" C\" & INDEX($C45:$AF45,COUNT($C45:$AF45))-7","v":"Y28 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C46:AF46) & \" C\" & INDEX($C46:$AF46,COUNT($C46:$AF46))-7","v":"Y29 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[{"$f":"\"Y\" & COUNT(C47:AF47) & \" C\" & INDEX($C47:$AF47,COUNT($C47:$AF47))-7","v":"Y30 C100"},null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,107]
[]
[]
["Present Value",null,"Initial Scenario","Scenario 1","Scenario 2","Scenario 3","Scenario 4",null,null,null,"Wi",null,"Initial Scenario","Scenario 1","Scenario 2","Scenario 3","Scenario 4"]
["Put",3,{"$f":"SUMPRODUCT($C22:$AF22,$C$15:$AF$15)","v":103.21952063934982},{"$f":"SUMPRODUCT($C22:$AF22,$C$16:$AF$16)","v":110.51088736732628},{"$f":"SUMPRODUCT($C22:$AF22,$C$17:$AF$17)","v":96.668216153835559},{"$f":"SUMPRODUCT($C22:$AF22,$C$18:$AF$18)","v":94.309097055275572},{"$f":"SUMPRODUCT($C22:$AF22,$C$19:$AF$19)","v":108.20678987792822},null,null,null,{"$f":"A51","v":"Put"},{"$f":"B51","v":3},{"$f":"IF(LOWER($K51)=\"put\",MAX(M52,C51),MIN(M52,C51))","v":106.74674021101292},119.23461948716185,97.208767704184083,94.309097055275572,114.48866983828157]
["Put",5,{"$f":"SUMPRODUCT($C23:$AF23,$C$15:$AF$15)","v":106.5911538256361},118.38570974522021,{"$f":"SUMPRODUCT($C23:$AF23,$C$17:$AF$17)","v":97.208767704184083},{"$f":"SUMPRODUCT($C23:$AF23,$C$18:$AF$18)","v":92.91130881370718},{"$f":"SUMPRODUCT($C23:$AF23,$C$19:$AF$19)","v":113.67860672258377},null,null,null,"Put",5,106.74674021101292,119.23461948716185,97.208767704184083,92.91130881370718,114.48866983828157]
["Call",5,{"$f":"SUMPRODUCT($C24:$AF24,$C$15:$AF$15)","v":107.34550168367403},119.23461948716185,{"$f":"SUMPRODUCT($C24:$AF24,$C$17:$AF$17)","v":97.889289612123534},{"$f":"SUMPRODUCT($C24:$AF24,$C$18:$AF$18)","v":93.556825496338718},{"$f":"SUMPRODUCT($C24:$AF24,$C$19:$AF$19)","v":114.48866983828157},null,null,null,"Call",5,106.74674021101292,119.23461948716185,95.831741270653538,88.271400632507863,114.48866983828157]
["Call",7,{"$f":"SUMPRODUCT($C25:$AF25,$C$15:$AF$15)","v":106.74674021101292},122.25066768374849,{"$f":"SUMPRODUCT($C25:$AF25,$C$17:$AF$17)","v":95.831741270653538},{"$f":"SUMPRODUCT($C25:$AF25,$C$18:$AF$18)","v":89.589278088066905},{"$f":"SUMPRODUCT($C25:$AF25,$C$19:$AF$19)","v":114.79032432516001},null,null,null,"Call",7,106.74674021101292,122.25066768374849,95.831741270653538,88.271400632507863,114.79032432516001]
["Put",8,{"$f":"SUMPRODUCT($C26:$AF26,$C$15:$AF$15)","v":106.87413294380457},124.05110433684908,{"$f":"SUMPRODUCT($C26:$AF26,$C$17:$AF$17)","v":95.506731898282908},{"$f":"SUMPRODUCT($C26:$AF26,$C$18:$AF$18)","v":88.271400632507863},{"$f":"SUMPRODUCT($C26:$AF26,$C$19:$AF$19)","v":115.09221919126674},null,null,null,"Put",8,108.91639949807453,129.53565127165376,96.918463905330469,88.271400632507863,115.77515608140453]
["Call","N",{"$f":"MIN(C59:C79)","v":108.91639949807453},{"$f":"MIN(D59:D79)","v":129.53565127165376},{"$f":"MIN(E59:E79)","v":96.918463905330469},{"$f":"MIN(F59:F79)","v":84.804771358898591},{"$f":"MIN(G59:G79)","v":115.77515608140453},null,null,null,"Call","N",{"$f":"C56","v":108.91639949807453},{"$f":"D56","v":129.53565127165376},96.918463905330469,84.804771358898591,115.77515608140453]
[null,null,{"$f":"INDEX($A$59:$A$79,MATCH(C56,C$59:C$79,0))","v":10},{"$f":"INDEX($A$59:$A$79,MATCH(D56,D$59:D$79,0))","v":10},{"$f":"INDEX($A$59:$A$79,MATCH(E56,E$59:E$79,0))","v":10},{"$f":"INDEX($A$59:$A$79,MATCH(F56,F$59:F$79,0))","v":23},{"$f":"INDEX($A$59:$A$79,MATCH(G56,G$59:G$79,0))","v":20},null,null,null,null,null,{"$f":"C57","v":10},10,10,23,20]
[]
[10,null,{"$f":"SUMPRODUCT($C27:$AF27,$C$15:$AF$15)","v":108.91639949807453},{"$f":"SUMPRODUCT($C27:$AF27,$C$16:$AF$16)","v":129.53565127165376},{"$f":"SUMPRODUCT($C27:$AF27,$C$17:$AF$17)","v":96.918463905330469},{"$f":"SUMPRODUCT($C27:$AF27,$C$18:$AF$18)","v":87.466625463805912},{"$f":"SUMPRODUCT($C27:$AF27,$C$19:$AF$19)","v":117.13532888310664}]
[{"$f":"A59+1","v":11},null,109.56181427039181,131.70228208699479,97.511187362681255,86.950415592196435,117.52857481098033,null,null,null,"Redemption Yr",null,{"$f":"IF(M81=1,M82,SUMPRODUCT(M76:M80,$L$76:$L$80))","v":7},{"$f":"IF(N81=1,N82,SUMPRODUCT(N76:N80,$L$76:$L$80))","v":5},{"$f":"IF(O81=1,O82,SUMPRODUCT(O76:O80,$L$76:$L$80))","v":5},{"$f":"IF(P81=1,P82,SUMPRODUCT(P76:P80,$L$76:$L$80))","v":3},{"$f":"IF(Q81=1,Q82,SUMPRODUCT(Q76:Q80,$L$76:$L$80))","v":5}]
[{"$f":"A60+1","v":12},null,110.1718471364762,133.74652517370015,98.198763784769952,86.511501241225147,117.75949402762325]
[13,null,110.74843774714196,135.67334359362093,98.971794612315506,86.14076075210501,117.84634024095482,null,null,null,null,{"$f":"L51","v":3},{"$f":"M51=C51","v":false},{"$f":"N51=D51","v":false},false,true,false]
[14,null,111.29341942073907,137.48761549501006,99.822427716512067,85.830132804913134,117.80661493666943,null,null,null,null,5,{"$f":"M52=C52","v":false},false,true,true,false]
[15,null,111.80852497234318,139.19412818648951,100.74416220678469,85.57249141190853,117.65697168666239,null,null,null,null,5,false,true,false,false,true]
[16,null,112.29539222338676,140.79757274394046,101.73168365105194,85.361536012198499,117.4131383949554,null,null,null,null,7,true,true,true,false,true]
[17,null,112.75556920925024,142.30253914285942,102.78072533977259,85.191694794251859,117.08985706402405,null,null,null,null,8,false,false,false,true,false]
[18,null,113.19051910137074,143.71351190699733,103.88795194098438,85.058039611504569,116.70084041465846,null,null,null,null,null,true,true,true,true,true]
[19,null,113.60162485951867,145.03486626249151,105.05086249679405,84.956211063820305,116.25874447605557]
[20,null,113.99019362903465,146.27086478522432,106.26771022194211,84.882352498052654,115.77515608140453,null,null,null,null,{"$f":"L62","v":3},{"$f":"OR(M$62:M62)","v":false},{"$f":"OR(N$62:N62)","v":false},{"$f":"OR(O$62:O62)","v":false},{"$f":"OR(P$62:P62)","v":true},{"$f":"OR(Q$62:Q62)","v":false}]
[21,null,114.42252927942511,147.51644933991554,106.73452829469664,84.835787803936043,116.06359434929681,null,null,null,null,5,{"$f":"OR(M$62:M63)","v":false},{"$f":"OR(N$62:N63)","v":false},{"$f":"OR(O$62:O63)","v":true},{"$f":"OR(P$62:P63)","v":true},{"$f":"OR(Q$62:Q63)","v":false}]
[22,null,114.83785744086502,148.69135392037666,107.18842452116277,84.810821820347186,116.34103548662743,null,null,null,null,5,{"$f":"OR(M$62:M64)","v":false},{"$f":"OR(N$62:N64)","v":true},{"$f":"OR(O$62:O64)","v":true},{"$f":"OR(P$62:P64)","v":true},{"$f":"OR(Q$62:Q64)","v":true}]
[23,null,115.23684449760476,149.79882101673468,107.62965356638969,84.804771358898591,116.60785264813313,null,null,null,null,7,{"$f":"OR(M$62:M65)","v":true},{"$f":"OR(N$62:N65)","v":true},{"$f":"OR(O$62:O65)","v":true},{"$f":"OR(P$62:P65)","v":true},{"$f":"OR(Q$62:Q65)","v":true}]
[24,null,115.62013289884386,150.8419884492024,108.05848099337554,84.815263495348873,116.86441167947251,null,null,null,null,8,{"$f":"OR(M$62:M66)","v":true},{"$f":"OR(N$62:N66)","v":true},{"$f":"OR(O$62:O66)","v":true},{"$f":"OR(P$62:P66)","v":true},{"$f":"OR(Q$62:Q66)","v":true}]
[25,null,115.98834176333966,151.82389025441711,108.47518092914322,84.8401999768937,117.11107064588111,null,null,null,null,null,{"$f":"OR(M$62:M67)","v":true},{"$f":"OR(N$62:N67)","v":true},{"$f":"OR(O$62:O67)","v":true},{"$f":"OR(P$62:P67)","v":true},{"$f":"OR(Q$62:Q67)","v":true}]
[26,null,116.34206749687867,152.74745772230864,108.88003399914462,84.877725791149786,117.34817945074397]
[27,null,116.68188441857802,153.61552057352819,109.2733255030541,84.926201398286295,117.57607953413765,null,null,null,null,{"$f":"L69","v":3},{"$f":"IF(AND(M69,NOT(M68)),1,0)","v":0},{"$f":"IF(AND(N69,NOT(N68)),1,0)","v":0},0,1,0]
[28,null,117.00834539246536,154.43080826757807,109.65534380760104,84.984178189102053,117.79510364234581,null,null,null,null,5,{"$f":"IF(AND(M70,NOT(M69)),1,0)","v":0},0,1,0,0]
[29,null,117.32198246121224,155.19595143192194,110.0263789344317,85.050376785431752,118.00557566022091,null,null,null,null,5,{"$f":"IF(AND(M71,NOT(M70)),1,0)","v":0},1,0,0,1]
[30,null,117.62330747929015,155.91348340250431,110.38672132311129,85.123667846115822,118.20781049905574,null,null,null,null,7,{"$f":"IF(AND(M72,NOT(M71)),1,0)","v":1},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF(AND(M73,NOT(M72)),1,0)","v":0},0,0,0,0]
[null,null,"base","up",null,"down",null,null,null,null,null,"N",{"$f":"IF(AND(M74,NOT(M73)),1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M57","v":10},{"$f":"N57","v":10},10,23,20]